Tabela LOrderIdentifier

Definicja tabeli LOrderIdentifier

Name

LOrderIdentifier

Code

LOrderIdentifier

Comment

 


Lista kolumn tabeli LOrderIdentifier

Name

Code

OrderID

OrderID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

OrderStatusID

OrderStatusID

Active

Active


Kolumna OrderID tabeli LOrderIdentifier

Definicja kolumny OrderID tabeli LOrderIdentifier

Name

OrderID

Code

OrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna IdentifierTypeID tabeli LOrderIdentifier

Definicja kolumny IdentifierTypeID tabeli LOrderIdentifier

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalValue tabeli LOrderIdentifier

Definicja kolumny ExternalValue tabeli LOrderIdentifier

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna OrderStatusID tabeli LOrderIdentifier

Definicja kolumny OrderStatusID tabeli LOrderIdentifier

Name

OrderStatusID

Code

OrderStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli LOrderIdentifier

Definicja kolumny Active tabeli LOrderIdentifier

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli LOrderIdentifier

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LOrderIdentifier

Definicja klucza Identifier_1 tabeli LOrderIdentifier

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment